/*******************************************************************************
   Database :free 
   Script: create_t.sql
   Description: create des tables t1 et t2.
   DB Server: Sqlite
   Author: Herve Meftah
   License: GPL
********************************************************************************/

/*******************************************************************************
   Drop Foreign Keys Constraints
********************************************************************************/


/*******************************************************************************
   Drop Tables
********************************************************************************/
DROP TABLE IF EXISTS [t1];

DROP TABLE IF EXISTS [t2];

/*******************************************************************************
   Create Tables
********************************************************************************/
CREATE TABLE [t1]
(
    [num] INTEGER PRIMARY KEY NOT NULL,
    [name] NVARCHAR(15)  NOT NULL
);

CREATE TABLE [t2]
(
    [num] INTEGER PRIMARY KEY  NOT NULL,
    [value] NVARCHAR(15)
);

/*******************************************************************************
   Populate Tables
********************************************************************************/
INSERT INTO [t1] ([num], [name]) VALUES (1, 'a');
INSERT INTO [t1] ([num], [name]) VALUES (2, 'b');
INSERT INTO [t1] ([num], [name]) VALUES (3, 'c');

INSERT INTO [t2] ([num], [value]) VALUES (1, 'xxx');
INSERT INTO [t2] ([num], [value]) VALUES (3, 'yyy');
INSERT INTO [t2] ([num], [value]) VALUES (5, 'zzz');


